﻿<%@ Page Language="VB" AutoEventWireup="true" CodeFile="frame2.aspx.vb" Inherits="frame2" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    <asp:GridView ID="GridView1"  DataSourceID="SqlDataSource1" 
            AutoGenerateColumns="False" runat="server" CellPadding="4" 
            ForeColor="#333333" GridLines="None">
        <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
 <Columns>
<asp:HyperLinkField HeaderText="Select a Movie" DataTextField="MovieTitle"  DataNavigateUrlFields="Movieid"  Target="frame3" DataNavigateUrlFormatString="frame3.aspx?movieid={0}"   />
 </Columns>
        <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White"  />
        <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
        <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
        <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
        <EditRowStyle BackColor="#999999" />
        <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
</asp:GridView> 

<asp:SqlDataSource ID="SqlDataSource1" runat="server" 
            ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
            
            
            SelectCommand="SELECT [TheatreId], [MovieTitle], [MovieId] FROM [Movie] WHERE (([TheatreId] = @TheatreId) AND ([Showing] = @Showing))">
    <SelectParameters>
        <asp:QueryStringParameter Name="TheatreId" QueryStringField="theatreid" 
            Type="Int16" />
        <asp:Parameter DefaultValue="true" Name="Showing" Type="Boolean" />
    </SelectParameters>
        </asp:SqlDataSource> 
    </div>
    </form>
</body>
</html>
